#! /bin/bash
export LANG=zh_CN.UTF-8
PRESTO_HOME=/export/server/presto/bin/presto


${PRESTO_HOME} --catalog hive --server 192.168.88.80:8090 --execute "
create table mysql.edu_olap.rpt_access_consul_area_count
as select * from hive.edu_rpt.rpt_access_consul_area_count;

create table mysql.edu_olap.rpt_access_consul_consul_rate
as select * from hive.edu_rpt.rpt_access_consul_consul_rate;

create table mysql.edu_olap.rpt_access_consul_from_url_count
as select * from hive.edu_rpt.rpt_access_consul_from_url_count;

create table mysql.edu_olap.rpt_access_consul_origin_channel_count
as select * from hive.edu_rpt.rpt_access_consul_origin_channel_count;

create table mysql.edu_olap.rpt_access_consul_seo_source_count
as select * from hive.edu_rpt.rpt_access_consul_seo_source_count;

create table mysql.edu_olap.rpt_access_consul_total_count
as select * from hive.edu_rpt.rpt_access_consul_total_count;
"